|
Function Call |
a |
b |
c |
d |
Return |
Description |
Example |
|
AddDays( a, b ) |
date |
number |
|
|
date |
Add a number of
whole days (b) to a date (a) |
adddays( date( 2020, 1, 1 ), 59 ) adddays( date( 2020, 3, 1 ), -1 ) |
|
AddHours( a, b ) |
time |
number |
|
|
time |
Add a number of
whole hours (b) to a time (a) |
addhours( time( 12, 1, 1 ), 23 ) addhours( time( 12, 1, 1 ), -13 ) |
|
AddMonths( a, b ) |
date |
number |
|
|
date |
Add a number of
whole months (b) to a date (a) |
addmonths( date( 2020, 1, 31 ), 1 ) addmonths( date( 2020, 3, 30 ), -1 ) |
|
AddMinutes( a, b ) |
time |
number |
|
|
time |
Add a number of
whole minutes (b) to a time (a) |
addminutes( time( 12, 1, 1 ), 23 ) addminutes( time( 12, 1, 1 ), -13 ) |
|
AddSeconds( a, b ) |
time |
number |
|
|
time |
Add a number of
whole seconds (b) to a time (a) |
addseconds( time( 12, 1, 1 ), 23 ) addseconds( time( 12, 1, 1 ), -13 ) |
|
AddYears( a, b ) |
date |
number |
|
|
date |
Add a number of
whole years (b) to a date (a) |
addyears( date( 2016, 2, 29 ), 4 ) addyears( date( 2024, 2, 29 ), -4 ) |
|
Ascending( a ) |
any[] |
|
|
|
any[] |
Sort a list in
ascending order |
ascending( list( "a", "c", "a", "b", "a" ) ) |
|
AtPosition( a, b ) |
any[] |
number |
|
|
any |
The item at a
specified position (b) in a list (a) |
atposition( list( "a", "c", "a", "b", "a" ), 2 ) |
|
Between( a, b ) |
number |
number |
|
|
number[] |
Construct a list
of numeric values between a lowerbound (a) and an upperbound (b), inclusive |
between( -3, 5 ) |
|
Cardinal( a ) |
number |
|
|
|
text |
Convert a number
to a cardinal number |
cardinal( 123 ) |
|
Concat( a, b, c, etc. ) |
text |
text |
text |
|
text |
Text
concatenation |
concat(
"alpha", "beta",
"gamma" ) |
|
Contains( a, b ) |
any[] |
any |
|
|
boolean |
Determine if the
list (a) contains the value (b) |
contains( list( "a", "b", "c" ), "b" ) contains( list( "a", "b", "c" ), "d" ) |
|
Count( a ) |
any[] |
|
|
|
|
The number of
items in a list |
count( list() ) count( list( "a", "b", "c" ) ) |
|
Date( a, b, c ) |
number |
number |
number |
|
date |
Convert a year
(a), month (b) and day (c) into a date literal |
date( 2020, 12, 31 ) |
|
DayOf( a ) |
date |
|
|
|
number |
The day component
of a date |
dayof( date( 2020, 2, 29 ) ) |
|
DaysBetween( a, b ) |
date |
date |
|
|
number |
The number of
whole days between two dates |
daysbetween( date( 2020, 2, 29 ), date( 2019, 12, 31 ) ) |
|
Descending( a ) |
any[] |
|
|
|
any[] |
Sort a list in
descending order |
descending( list( "a", "c", "a", "b", "a" ) ) |
|
Difference( a, b ) |
any[] |
any[] |
|
|
any[] |
The difference
between two distinct lists |
difference( list( "a", "c", "a", "b", "a" ), list( "a" ) ) difference( list( "a", "c", "a", "b", "a" ), list( "b" ) ) |
|
Distinct( a ) |
any[] |
|
|
|
any[] |
Remove duplicates
from a list |
distinct( list("a","c","a","b","a") ) |
|
Factorial( a ) |
number |
|
|
|
number |
The factorial of
a number |
factorial( 4 ) |
|
FirstOf( a ) |
any[] |
|
|
|
any |
The first item in
a list |
firstof( list("c","a","b","a") ) |
|
Format( a, b, c ) |
any |
text |
text |
|
Format a boolean,
number, date, or list (a) as specified by the optional format (b) in the
optional locale (c) |
format( date( 2020, 3, 31 ) ) format( list( "A", "B", "C"),
"oxfordcomma" ) format( 1234567.8,
"precision2", "france" ) |
|
|
FormatSentence( a ) |
Text |
|
Format the text
as if it were one or more sentences |
FormatSentence( "the quick
brown fox jumped" ) FormatSentence( "the
quick.brown fox.jumped" ) |
|||
|
HourOf( a ) |
time |
|
|
|
number |
The hour component
of a time |
hourof( time( 20, 2, 29 ) ) |
|
HoursBetween( a, b ) |
time |
time |
|
|
number |
The number of
whole hours between two times |
hoursbetween( time( 20, 2, 29 ), time( 23, 12, 31 ) ) |
|
Intersection( a, b ) |
any[] |
any[] |
|
|
any[] |
The intersection
of two distinct lists |
intersection( list( "a", "c", "a", "b", "a" ), list( "a" ) ) intersection( list( "a", "c", "a", "b", "a" ), list( "b", "a" ) ) |
|
IsaEquivalence( a, b ) |
any[] |
any[] |
|
|
any[] |
Test if two
distinct lists have exactly the same membership |
isaequivalence( list( "a", "c", "a", "b", "a" ), list( "a" ) ) isaequivalence ( list( "a", "c", "b" ), list("c", "b", "a" ) ) |
|
IsaLeapYear( a ) |
date |
|
|
|
boolean |
Determines if a
date is in a leap year |
isaleapyear( date( 2020, 12, 31 ) ) isaleapyear( date( 2000, 12, 31 ) ) |
|
IsaSubset( a, b ) |
any[] |
any[] |
|
|
any[] |
Test if two
distinct lists have exactly the same membership |
isasubset( list( "a", "c", "a", "b", "a" ), list( "a" ) ) isasubset ( list( "a", "c", "b" ), list("c", "b", "a" ) ) |
|
Join( a, b, c, d, etc ) |
any[] |
any[] |
any[] |
any[] |
any[] |
Join multiple
lists together into a single list |
join( list( "a", "b", "c", "d" ), list( "e", "f" ) ) |
|
Known( a ) |
any |
|
|
|
boolean |
Determines if the
value is known |
known( date( 2020, 12, 31 ) ) known( unknown ) |
|
KnownFalse( a ) |
boolean |
|
|
|
boolean |
Determines if the
value is known and false |
knownfalse( isaleapyear( date( 2020, 12, 31 ) ) ) knownfalse( isaleapyear( date( 2021, 12, 31 ) ) ) knownfalse( unknown ) |
|
KnownTrue( a ) |
boolean |
|
|
|
boolean |
Determines if the
value is known and true |
knowntrue( isaleapyear( date( 2020, 12, 31 ) ) ) knowntrue( isaleapyear( date( 2021, 12, 31 ) ) ) knowntrue( unknown ) |
|
Lambda( a, b ) |
any[] |
text |
|
|
any[] |
Apply a funtion
to a list |
lambda( list( "", "a", "ab" ), "Length" ) lambda( list( list( "a" ), list( "a", "b", "c" ) ), "Format", " ; " ) |
|
LastDayOfMonth( a ) |
date |
|
|
|
number |
The last day of
the month for a date |
lastdayofmonth( date( 2020, 2, 1 ) ) |
|
LastOf( a ) |
any[] |
|
|
|
any |
The last item in
a list |
lastof( list("a","c","a","b") ) |
|
Length( a ) |
text |
|
|
|
number |
The number of
characters in some text |
length(
"Alpha" ) length( "" ) |
|
List( a, b, c, d, etc. ) |
any |
any |
any |
any |
any[] |
Construct a list
from its members |
list( "alpha", "beta" ) |
|
LocaleCode( a ) |
text |
|
|
text |
The culture code
of the specified locale identifier, or |
localecode( "default"
) |
|
|
LocaleCountry( a ) |
text |
|
|
text |
The country of
the specified locale identifier, or |
localecountry("default"
) |
|
|
LocaleCurrency( a ) |
text |
|
|
text |
The currency of
the specified locale identifier, or |
localecurrency("default"
) |
|
|
LocaleLanguage( a ) |
text |
|
|
text |
The language of
the specified locale identifier, or |
localelanguage("default"
) |
|
|
LocaleMonth( a, b, c ) |
integer text |
boolean |
text |
|
text integer |
Convert between a
month number and its localised name Optional boolean
to indicate abbreviated names Optional
specified locale identifier |
localemonth( 6 ) localemonth( "JUNE" ) localemonth ( 6, true ) localemonth( "jun", true ) |
|
LocaleMonths( a, b, c, d ) |
integer |
integer |
boolean |
text |
text[] |
The month names Optional boolean
to indicate abbreviated names Optional
specified locale identifier |
localemonths() localemonths( 6 ) localemonths( 6, 9 ) localemonths( 6, 9, true ) |
|
LocaleName( a ) |
text |
|
|
text |
The name of the
specified locale identifier, or |
localename("default"
) |
|
|
LocaleWeekday( a, b, c ) |
integer text |
boolean |
text |
|
text integer |
Convert between a
weekday number and its localised name Optional boolean
to indicate abbreviated names Optional
specified locale identifier |
localeweekday( 6 ) localeweekday( "SATURDAY"
) localeweekday( 6, true ) localeweekday( "SAT", true ) |
|
LocaleWeekdays(a,b,c,d) |
integer |
integer |
boolean |
text |
text[] |
The weekday names Optional boolean
to indicate abbreviated names Optional
specified locale identifier |
localeweekdays() localeweekdays( 7 ) localeweekdays( 6, 7 ) localeweekdays( 6, 7, true ) |
|
LowerCase( a ) |
text |
|
|
|
text |
Convert text to
lowercase |
lowercase(
"Alpha" ) |
|
Mean( a ) |
number[] |
|
|
|
number |
The mean value of
a list of numbers |
mean( list( 1, 2, 3, 4 ) ) |
|
Median( a ) |
number[] |
|
|
|
number |
The median value
of a list of numbers |
median( list( 1, 2, 3, 4 ) ) median( list( 1, 2, 3, 4, 5 ) ) |
|
MinuteOf( a ) |
time |
|
|
|
number |
The minute
component of a time |
minuteof( time( 20, 2, 29 ) ) |
|
MinutesBetween( a, b ) |
time |
time |
|
|
number |
The number of
whole minutes between two times |
minutesbetween( time( 20, 2, 29 ), time( 23, 12, 31 ) ) |
|
Mode( a ) |
any[] |
|
|
|
any |
The mode (first
most common) item in a list |
mode( list( 1, 2, 3, 2, 3 ) ) mode( list( "c", "a", "b", "b", "d" ) ) |
|
MonthOf( a ) |
date |
|
|
|
number |
The month
component of a date |
monthof( date( 2020, 2, 29 ) ) |
|
MonthsBetween( a, b ) |
date |
date |
|
|
number |
The number of
whole months between two dates |
monthsbetween( date( 2020, 2, 29 ), date( 2019, 12, 31 ) ) |
|
NearestWeekday( a, b ) |
date |
number |
|
|
date |
The nearest
weekday (b) either before (negative weekday) or after (positive weekday) a
specified date (a), where weekdays range from 1 (Monday) to 7 (Sunday) |
nearestweekday( date( 2020, 2, 29 ), 1 ) nearestweekday( date( 2020, 2, 29 ), -4 ) |
|
Ordinal( a ) |
number |
|
|
|
text |
Convert a number
to ordinal words |
ordinal( 123 ) = "one
hundred and twenty third" |
|
OrdinalSuffix( a ) |
number |
|
|
|
text |
The ordinal
suffix of a number |
ordinalsuffix( 123 ) =
"123rd" |
|
PositionOf( a, b ) |
any[] |
any |
|
|
number |
The first
position of an item (b) in a list (a) |
positionof( list( "c", "a", "b", "b", "d" ), "b" ) |
|
Product( a ) |
number[] |
|
|
|
number |
The product of a
list of numbers |
median( list( 1, 2, 3, 4, 5 ) ) |
|
ReplaceAll( a, b, c ) |
text |
text |
text |
|
Text |
Replace all
occurrences of a sub-text with a replacement text |
replaceall(
"AlphaBeta", "a", "a?" ) replaceall(
"AlphaBeta", "A", "" ) |
|
Reverse( a ) |
any[] |
|
|
|
any[] |
Reverse the order
of a list |
reverse( list( "c", "a", "b", "b", "d" ) ) |
|
RoundAwayZero( a, b ) |
number |
integer |
|
|
number |
Round a number
(a) to a precision (b), away from zero for .0…05 |
roundawayzero( 0.012345, 5 ) |
|
RoundBankers( a, b ) |
number |
integer |
|
|
number |
Round a number
(a) to a precision (b), away from zero for .0…0(even) and towards zero for
.0…0(odd) |
roundbankers( 0.012345, 5 ) roundbankers( 0.012435, 5 ) |
|
RoundTowardsZero( a, b ) |
number |
integer |
|
|
number |
Round a number
(a) to a precision (b), towards zero for .0…05 |
roundtowardszero( 0.012345, 5 ) |
|
SecondOf( a ) |
time |
|
|
|
number |
The second
component of a time |
secondof( time( 20, 2, 29 ) ) |
|
SecondsBetween( a, b ) |
time |
time |
|
|
number |
The number of
whole seconds between two times |
secondsbetween( time( 20, 2, 29 ), time( 23, 12, 31 ) ) |
|
SubText( a, b, c ) |
text |
integer |
integer |
|
Text |
The sub-text at a
specific position and length (optional), either from the start or from the
end |
subtext(
"AlphaBeta", 6, 3 ) subtext(
"AlphaBeta", -6, 3 ) |
|
Sum( a ) |
number[] |
|
|
|
number |
The sum of a list
of numbers |
median( list( 1, 2, 3, 4, 5 ) ) |
|
Term( a, b, c ) |
date time |
date time |
text text |
|
text text |
The term between
two dates expressed as years, months, weeks, and days determined by the optional
format (c) The term between
two times expressed as hours, minutes, and seconds determined by the optional
format (c) |
term( date( 2020, 1, 1 ), date( 2021, 3, 3 ) ) 1 Year,2 Months,3 Days term( time( 18, 30, 45 ), time( 3, 45, 30 ) ) |
|
Time( a, b, c ) |
number |
number |
number |
|
time |
Convert an hour
(a), minute (b) and second (c) into a time literal |
time( 18, 30, 45 ) |
|
ToBoolean( a ) |
any |
|
|
|
boolean |
Cast a text or
numeric value to a boolean |
toboolean( "tRUe" ) true toboolean( "truth" ) false toboolean( 1 ) true toboolean( -1 ) false |
|
ToDate( a ) |
any |
|
|
|
date |
Cast a text or
numeric value to a date, where a numeric value represents the number of days
since 1970-01-01 |
todate( "2020-02-29" ) 29th of February,
2020 todate( 18321 ) 29th of February,
2020 |
|
Today() |
|
|
|
|
date |
Today as a date
literal |
today() |
|
ToInteger( a ) |
text |
|
|
|
number |
Convert text into
a whole number |
tointeger(
"123.45" ) |
|
ToLetters( a ) |
number |
|
|
|
string |
Convert a number
to a series of uppercase letters |
toletters( 27 ) |
|
ToNumber( a ) |
text |
|
|
|
number |
Convert text into
a number |
tonumber(
"123.45" ) |
|
ToRoman( a ) |
number |
|
|
|
string |
Convert a number
to Roman numerals |
toroman( 27 ) |
|
ToText( a ) |
any |
|
|
|
text |
Convert a value
to text |
totext( 123.45 ) |
|
ToTime( a ) |
any |
|
|
|
time |
Cast a text or
numeric value to a time, where a numeric value represents the number of
seconds since midnight |
totime( "1:2:3" ) 01:02:03 totime( 3723 ) 01:02:03 |
|
Union( a, b ) |
any[] |
any[] |
|
|
any[] |
The union of two
distinct lists |
union( list( "a", "c", "a", "b", "a" ), list( "a" ) ) intersection( list( "a", "c", "a", "b", "a" ), list( "b",
"d" ) ) |
|
UpperCase( a ) |
text |
|
|
|
text |
Convert text to
uppercase |
uppercase(
"Alpha" ) |
|
WeekdayOf( a ) |
date |
|
|
|
|
The weekday of a
date, where weekdays range from 1 (Monday) to 7 (Sunday) |
weekday( date( 2020, 2, 29 ) ) 6 |
|
WeekNumber( a ) |
date |
|
|
|
number |
The week number
(1-53) of a date in that particular year |
weeknumber( date( 2020, 2, 29 ) ) weeknumber( date( 2021, 2, 28 ) ) |
|
WorkDay( a, b, c, d ) |
date |
integer |
date[] |
integer[] |
date |
The date that is
a number of working days (b) after
the specified date (a) Working days are
defined as Mon-Fri unless otherwise
specified by the optional non-working days (d) and the optional exclusion
dates (c) |
adddays( date( 2008, 10, 1 ) , 151 ) workday( date( 2008, 10, 1 ) , 151 ) workday( date( 2008, 10, 1 ), 151, list( date( 2008, 11, 26 ), date( 2008, 12, 4 ), date( 2009, 1, 21 ) ) ) workday( date( 2008, 10, 1 ), 151, list( date( 2008, 11, 26 ), date( 2008, 12, 4 ), date( 2009, 1, 21 ), list(5,6,7) ) ) |
|
YearOf( a ) |
date |
|
|
|
number |
The year
component of a date |
yearof( date( 2020, 2, 29 ) ) |
|
YearsBetween( a, b ) |
date |
date |
|
|
number |
The number of
whole years between two dates |
yearsbetween( date( 2020, 2, 29 ), date( 2017, 12, 31 ) ) |
|
Function Call |
Description |
|
AddDays( date, number ) |
Add a number of
whole days (b) to a date(a) |
|
AddMonths( date, number ) |
Add a number of
whole months (b) to a date (a) |
|
AddYears( date, number ) |
Add a number of
whole years (b) to a date (a) |
|
Date( number, number, number ) |
Convert a year
(a), month (b) and day (c) into a date literal |
|
DayOf( date ) |
The day component
of a date |
|
DaysBetween( date, date ) |
The number of
whole days between two dates |
|
IsaLeapYear( date ) |
Determines if a
date is in a leap year |
|
LastDayOfMonth( date ) |
The last day of
the month for a date |
|
MonthOf( date ) |
The month
component of a date |
|
MonthsBetween( date, date ) |
The number of
whole months between two dates |
|
NearestWeekday( date, number ) |
The nearest
weekday (b) either before (negative weekday) or after (positive weekday) a
specified date (a), where weekdays range from 1 (Monday) to 7 (Sunday) |
|
Term( date, date, text ) |
The term between
two dates expressed as years, months, weeks, and days determined by the optional
format |
|
WeekdayOf( date ) |
The weekday of a
date, where weekdays range from 1 (Monday) to 7 (Sunday) |
|
WeekNumber( date ) |
The week number
(1-53) of a date in that particular year |
|
WorkDay( date, integer, date[], integer [] ) |
The date that is
a number of working days after the
specified date Working days are
defined as Mon-Fri unless otherwise specified by the optional non-working
days and the optional exclusion dates |
|
YearOf( date ) |
The year
component of a date |
|
YearsBetween( date, date ) |
The number of
whole years between two dates |
|
Function Call |
Description |
|
AddHours( time, number ) |
Add a number of
whole hours (b) to a time (a) |
|
AddMinutes( time, number ) |
Add a number of
whole minutes (b) to a time (a) |
|
AddSeconds( time, number ) |
Add a number of
whole seconds (b) to a time (a) |
|
HourOf( time ) |
The hour
component of a time |
|
HoursBetween( time, time ) |
The number of
whole hours between two times |
|
MinuteOf( time ) |
The minute
component of a time |
|
MinutesBetween( time, time ) |
The number of
whole minutes between two times |
|
SecondOf( time ) |
The second
component of a time |
|
SecondsBetween( time, time ) |
The number of
whole seconds between two times |
|
Term( time, time, text ) |
The term between
two times expressed as hours, minutes, and seconds determined by the
optional format |
|
Time( number, number, number ) |
Convert an hour (a),
minute (b) and second (c) into a time literal |
|
Function Call |
Description |
|
Between( number, number ) |
Construct a list
of numeric values between a lowerbound (a) and an upperbound (b), inclusive |
|
Cardinal( number ) |
Convert a number
to a cardinal number |
|
Factorial( number ) |
The factorial of
a number |
|
Mean( number[] ) |
The mean value of
a list of numbers |
|
Median( number[] ) |
The median value
of a list of numbers |
|
Mode( any[] ) |
The mode (first
most common) item in a list |
|
Ordinal( number ) |
Convert a number
to ordinal words |
|
OrdinalSuffix( number ) |
The ordinal
suffix of a number |
|
Product( number ) |
The product of a list
of numbers |
|
RoundAwayZero( number, number ) |
Round a number
(a) to a precision (b), away from zero for .0…05 |
|
RoundBankers( number, number ) |
Round a number
(a) to a precision (b), away from zero for .0…05(even) and towards zero for
.0…05(odd) |
|
RoundTowardsZero( number, number ) |
Round a number
(a) to a precision (b), towards zero for .0…05 |
|
Sum( number[] ) |
The sum of a list
of numbers |
|
Function
Call |
Description |
|
Concat( text, text, text, text, etc. ) |
Text concatenation |
|
FormatSentence( text ) |
Format the text as if it were one or more sentences |
|
Length( text ) |
The number of characters in some text |
|
LowerCase( text ) |
Convert text to lowercase |
|
ReplaceAll( text, text, text ) |
Replace all occurrences of a sub-text with a
replacement text |
|
SubText( text, text, text, boolean ) |
The sub-text at a specific position and length
(optional), either from the start or from the end |
|
UpperCase( text ) |
Convert text to uppercase |
|
Function
Call |
Description |
|
Ascending( any[] ) |
Sort a list in ascending order |
|
AtPosition( any[], number ) |
The item at a specified position (b) in a list (a) |
|
Contains( any[], any ) |
Determine if the list (a) contains the value (b) |
|
Count( any[] ) |
The number of items in a list |
|
Descending( any[] ) |
Sort a list in descending order |
|
Difference( any[], any[] ) |
The difference between two distinct lists |
|
Distinct( any[] ) |
Remove duplicates from a list |
|
FirstOf( any[] ) |
The first item in a list |
|
Intersection( any[], any[] ) |
The intersection of two distinct lists |
|
IsaEquivalence( any[], any[] ) |
Test if two distinct lists have exactly the same
membership |
|
IsaSubset( any[], any[] ) |
Test if two distinct lists have exactly the same
membership |
|
Join( any[], any[], any[], any[], etc ) |
Join multiple lists together into a single list |
|
Lambda( any[], text ) |
Apply a funtion to a list |
|
LastOf( any[] ) |
The last item in a list |
|
List( any, any, any, any, etc ) |
Construct a list from its members |
|
Mean( number[] ) |
The mean value of a list of numbers |
|
Median( number[] ) |
The median value of a list of numbers |
|
Mode( any[] ) |
The mode (first most common) item in a list |
|
PositionOf( any[], any ) |
The first position of an item (b) in a list (a) |
|
Reverse( any[] ) |
Reverse the order of a list |
|
Sum( number[] ) |
The sum of a list of numbers |
|
Union( any[], any[] ) |
The union of two distinct lists |
|
Function
Call |
Description |
|
ToBoolean( a ) |
Cast a text or numeric value to a boolean |
|
ToDate( a ) |
Cast a text or numeric value to a date, where a
numeric value represents the number of days since 1970-01-01 |
|
ToInteger( a ) |
Convert text into a whole number |
|
ToLetters( a ) |
Convert a number to a series of uppercase letters |
|
ToNumber( a ) |
Convert text into a number |
|
ToRoman( a ) |
Convert a number to Roman numerals |
|
ToText( a ) |
Convert a value to text |
|
ToTime( a ) |
Cast a text or numeric value to a time, where a
numeric value represents the number of seconds since midnight |
|
Function
Call |
Description |
|
LocaleCode( text ) |
The culture code of the specified locale identifier,
or the last locale to be configured |
|
LocaleCountry( text ) |
The country of the specified locale identifier, or the
last locale to be configured |
|
LocaleCurrency( text ) |
The currency of the specified locale identifier, or
the last locale to be configured |
|
LocaleLanguage( text ) |
The language of the specified locale identifier, or
the last locale to be configured |
|
LocaleMonth( number||text, boolean, text ) |
Convert between a month number and its localised
name |
|
LocaleMonths( integer, integer ) |
The month names |
|
LocaleName( text ) |
The name of the specified locale identifier, or the
last locale to be configured |
|
LocaleWeekday( number||text, boolean, text ) |
Convert between a weekday number and its localised
name |
|
LocaleWeekdays( integer, integer ) |
The weekday names |
|
Test |
a |
b |
c |
d |
Expected |
Actual |
|
AddDays( a, b ) |
2020-01-31 |
0 |
|
|
2020-01-31 |
|
|
|
2020-01-31 |
1 |
|
|
2020-02-01 |
|
|
|
2020-01-31 |
365 |
|
|
2020-01-30 |
|
|
|
2020-01-31 |
-365 |
|
|
2019-01-31 |
|
|
AddHours( a, b ) |
12:00:00 |
0 |
|
|
12:00:00 |
|
|
|
12:00:00 |
1 |
|
|
13:00:00 |
|
|
|
12:00:00 |
23 |
|
|
11:00:00 |
|
|
|
12:00:00 |
-23 |
|
|
13:00:00 |
|
|
AddMinutes( a, b ) |
12:00:00 |
0 |
|
|
12:00:00 |
|
|
|
12:00:00 |
1 |
|
|
12:01:00 |
|
|
|
12:00:00 |
89 |
|
|
13:29:00 |
|
|
|
12:00:00 |
-89 |
|
|
10:31:00 |
|
|
AddMonths( a, b ) |
2020-01-31 |
0 |
|
|
2020-01-31 |
|
|
|
2020-01-31 |
1 |
|
|
2020-02-29 |
|
|
|
2020-01-31 |
-11 |
|
|
2019-02-28 |
|
|
AddSeconds( a, b ) |
12:00:00 |
0 |
|
|
12:00:00 |
|
|
|
12:00:00 |
1 |
|
|
12:00:01 |
|
|
|
12:00:00 |
89 |
|
|
12:01:29 |
|
|
|
12:00:00 |
-89 |
|
|
11:58:31 |
|
|
AddYears( a, b ) |
2020-01-31 |
0 |
|
|
2020-01-31 |
|
|
|
2020-01-31 |
1 |
|
|
2021-01-31 |
|
|
|
2020-01-31 |
-1 |
|
|
2019-01-31 |
|
|
Ascending( a ) |
Empty
List |
|
|
|
Empty |
|
|
|
b,a,c,a,d,b,a |
|
|
|
a,a,a,b,b,c,d |
|
|
AtPosition( a, b ) |
b,a,c,a,d,b,a |
3 |
|
|
c |
|
|
|
b,a,c,a,d,b,a |
7 |
|
|
a |
|
|
|
b,a,c,a,d,b,a |
8 |
|
|
... |
|
|
Between( a, b ) |
1 |
1 |
|
|
1 |
|
|
|
-3 |
5 |
|
|
-3,-2,-1,0,1,2,3,4,5 |
|
|
|
5 |
-3 |
|
|
5,4,3,2,1,0,-1,-2,-3 |
|
|
Cardinal( a ) |
0 |
|
|
|
Zero |
|
|
|
12 |
|
|
|
Twelve |
|
|
|
100 |
|
|
|
One Hundred |
|
|
|
101 |
|
|
|
One Hundred and One |
|
|
|
123 |
|
|
|
One Hundred and Twenty Three |
|
|
|
200 |
|
|
|
Two Hundred |
|
|
|
1000 |
|
|
|
One Thousand |
|
|
|
1001 |
|
|
|
One Thousand and One |
|
|
|
4000 |
|
|
|
Four Thousand |
|
|
|
12345 |
|
|
|
Twelve Thousand Three Hundred and Forty Five |
|
|
|
5000000 |
|
|
|
Five Million |
|
|
|
1234567890 |
|
|
|
One Billion Two Hundred and Thirty Four Million Five Hundred and Sixty Seven Thousand Eight Hundred and Ninety |
|
|
|
6000000000 |
|
|
|
Six Billion |
|
|
|
7000000000000 |
|
|
|
Seven Thousand Billion |
|
|
|
30000001234567890 |
|
|
|
Three Million and One Billion Two Hundred and Thirty Four Million Five Hundred and Sixty Seven Thousand Eight Hundred and Ninety |
|
|
Concat( a, b, c, etc. ) |
|
|
|
|
Empty |
|
|
|
Alpha |
|
|
|
Alpha |
|
|
|
Alpha |
Beta |
|
|
AlphaBeta |
|
|
|
Alpha |
Beta |
Gamma |
|
AlphaBetaGamma |
|
|
Contains( a, b ) |
Empty List |
a |
|
|
No |
|
|
|
b,a,c,a,d,b,a |
a |
|
|
Yes |
|
|
|
b,a,c,a,d,b,a |
d |
|
|
Yes |
|
|
|
b,a,c,a,d,b,a |
e |
|
|
No |
|
|
Count( a ) |
Empty List |
|
|
|
0 |
|
|
|
b,a,c,a,d,b,a |
|
|
|
7 |
|
|
Date( a, b, c ) |
2020-1-31 |
|
|
|
2020-01-31 |
|
|
|
2020-2-29 |
|
|
|
2020-02-29 |
|
|
DayOf( a ) |
2020-01-31 |
|
|
|
31 |
|
|
|
2020-01-01 |
|
|
|
1 |
|
|
DaysBetween( a, b ) |
2020-01-31 |
2021-01-31 |
|
|
366 |
|
|
|
2021-01-31 |
2022-01-31 |
|
|
365 |
|
|
|
2022-01-31 |
2021-01-31 |
|
|
-365 |
|
|
|
2021-01-31 |
2020-01-31 |
|
|
-366 |
|
|
Descending( a ) |
Empty List |
|
|
|
Empty |
|
|
|
b,a,c,a,d,b,a |
|
|
|
d,c,b,b,a,a,a |
|
|
Difference( a, b ) |
b,a,c,a,d,b,a |
a,b,c,d |
|
|
Empty |
|
|
|
b,a,c,a,d,b,a |
|
|
|
b,a,c,d |
|
|
|
b,a,c,a,d,b,a |
b,d |
|
|
a,c |
|
|
Distinct( a ) |
Empty List |
|
|
|
Empty |
|
|
|
b,a,c,a,d,b,a |
|
|
|
b,a,c,d |
|
|
Factorial( a ) |
0 |
|
|
|
0 |
|
|
|
1 |
|
|
|
1 |
|
|
|
3 |
|
|
|
6 |
|
|
|
5 |
|
|
|
120 |
|
|
FormatSentence( a ) |
the quick brown fox jumped |
|
|
|
The quick brown fox jumped. |
|
|
|
the quic.brown fox.jumped |
|
|
|
The quick. Brown fox. Jumped. |
|
|
FirstOf( a ) |
Empty List |
|
|
|
... |
|
|
|
b,a,c,a,d,b,a |
|
|
|
b |
|
|
Format( a, b, c ) |
|
|
|
|
|
See
the document Formatting.docx |
|
HourOf( a ) |
12:00:00 |
|
|
|
12 |
|
|
|
23:59:58 |
|
|
|
23 |
|
|
HoursBetween( a, b ) |
12:00:00 |
23:59:58 |
|
|
11 |
|
|
|
23:59:58 |
11:59:58 |
|
|
-12 |
|
|
Intersection( a, b ) |
b,a,c,a,d,b,a |
Empty List |
|
|
Empty |
|
|
|
b,a,c,a,d,b,a |
a,b,c,d |
|
|
b,a,c,d |
|
|
|
b,a,c,a,d,b,a |
a,d |
|
|
a,d |
|
|
IsaEquivalence( a, b ) |
Empty List |
Empty List |
|
|
Yes |
|
|
|
b,a,c,a,d,b,a |
a,b,c,d |
|
|
Yes |
|
|
|
b,a,c,a,d,b,a |
Empty List |
|
|
No |
|
|
|
b,a,c,a,d,b,a |
e |
|
|
No |
|
|
IsaLeapYear( a ) |
2020-01-31 |
|
|
|
Yes |
|
|
|
2000-01-31 |
|
|
|
Yes |
|
|
|
3000-01-31 |
|
|
|
No |
|
|
|
2021-01-31 |
|
|
|
No |
|
|
IsaSubset( a, b ) |
Empty List |
Empty List |
|
|
Yes |
|
|
|
Empty List |
b,a,c,a,d,b,a |
|
|
Yes |
|
|
|
d,a,b |
b,a,c,a,d,b,a |
|
|
Yes |
|
|
|
b,a,c,a,d,b,a |
Empty List |
|
|
No |
|
|
|
b,a,c,a,d,b,a |
d,a,b |
|
|
No |
|
|
Join( a, b, c, d, etc ) |
a,b,c,d |
e,f |
|
|
a,b,c,d,e,f |
|
|
Known( a ) |
true |
|
|
|
Yes |
|
|
|
false |
|
|
|
Yes |
|
|
|
0 |
|
|
|
Yes |
|
|
|
2020-01-31 |
|
|
|
Yes |
|
|
|
unknown |
|
|
|
No |
|
|
Lambda( a, b ) |
Empty List |
Length |
|
|
Empty |
|
|
|
a,bb,ccc |
Length |
|
|
1,2,3 |
|
|
|
2020-1-31,2020-2-28 |
LastDayOfMonth |
|
|
31,29 |
|
|
|
2020-1-31,2020-2-28 |
AddDays |
1 |
|
2020-02-01,2020-02-29 |
|
|
LastDayOfMonth( a ) |
2020-01-01 |
|
|
|
31 |
|
|
|
2020-02-01 |
|
|
|
29 |
|
|
|
2000-02-01 |
|
|
|
29 |
|
|
|
3000-02-01 |
|
|
|
28 |
|
|
|
2020-04-01 |
|
|
|
30 |
|
|
LastOf( a ) |
Empty List |
|
|
|
... |
|
|
|
b,a,c,a,d,b,a |
|
|
|
a |
|
|
Length( a ) |
Empty Text |
|
|
|
0 |
|
|
|
a |
|
|
|
1 |
|
|
|
Alpha Beta |
|
|
|
10 |
|
|
List( a, b, c, etc. ) |
|
|
|
|
Empty |
|
|
|
Alpha |
|
|
|
Alpha |
|
|
|
Alpha |
Beta |
|
|
Alpha,Beta |
|
|
|
Alpha |
Beta |
Gamma |
|
Alpha,Beta,Gamma |
|
|
LocaleCode( a ) |
builtin |
|
|
|
en-US |
|
|
default |
|
|
|
en-US |
|
|
|
LocaleCountry( a ) |
builtin |
|
|
|
United States of America |
|
|
|
default |
|
|
|
United States of America |
|
|
LocaleCurrency( a ) |
builtin |
|
|
|
USD |
|
|
|
default |
|
|
|
USD |
|
|
LocaleLanguage( a ) |
builtin |
|
|
|
English |
|
|
|
default |
|
|
|
English |
|
|
LocaleMonth( a, b, c ) |
6 |
|
|
|
June |
|
|
|
JUNE |
|
|
|
6 |
|
|
6 |
true |
|
|
Jun |
|
|
|
|
jun |
true |
|
|
6 |
|
|
LocaleMonths( a, b, c , d ) |
|
|
January, February, March, April, May, June, July, August, September, October, Novovember, December |
|
||
|
6 |
|
|
June, July, August, September, October, November, December, January, February, March, April, May |
|
||
|
6 |
9 |
|
|
June, July, August, September |
|
|
|
6 |
9 |
true |
|
Jun, Jul, Aug, Sep |
|
|
|
LocaleName( a ) |
builtin |
|
|
|
Built-In Locale |
|
|
|
default |
|
|
|
United States Locale |
|
|
LocaleWeekday( a, b, c ) |
6 |
|
|
|
Saturday |
|
|
|
SATURDAY |
true |
|
|
6 |
|
|
6 |
true |
|
|
Sat |
|
|
|
|
sat |
|
|
|
6 |
|
|
LocaleWeekdays(a,b,c,d) |
|
|
Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday |
|
||
|
7 |
|
|
Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday |
|
||
|
6 |
7 |
|
|
Saturday, Sunday |
|
|
|
6 |
7 |
true |
|
Sat, Sun |
|
|
|
LowerCase( a ) |
Empty Text |
|
|
|
Empty |
|
|
|
AlphaBetaGamma |
|
|
|
alphabetagamma |
|
|
Mean( a ) |
Empty List |
|
|
|
... |
|
|
|
2,1,4,3 |
|
|
|
2.5 |
|
|
|
2,5,1,4,3 |
|
|
|
3 |
|
|
Median( a ) |
Empty List |
|
|
|
... |
|
|
|
2,1,4,3 |
|
|
|
2 |
|
|
|
2,5,1,4,3 |
|
|
|
3 |
|
|
MinuteOf( a ) |
12:00:00 |
|
|
|
0 |
|
|
|
23:59:58 |
|
|
|
59 |
|
|
MinutesBetween( a, b ) |
12:00:00 |
23:59:58 |
|
|
719 |
|
|
|
23:59:58 |
11:59:58 |
|
|
-720 |
|
|
Mode( a ) |
Empty List |
|
|
|
... |
|
|
|
b,a,c,a,d,b,a |
|
|
|
a |
|
|
|
b,a,c,c,c,a,d,b,a |
|
|
|
a |
|
|
|
b,a,c,c,c,c,a,d,b,a |
|
|
|
c |
|
|
MonthOf( a ) |
2020-01-31 |
|
|
|
1 |
|
|
|
2020-02-29 |
|
|
|
2 |
|
|
|
2020-12-31 |
|
|
|
12 |
|
|
MonthsBetween( a, b ) |
2020-01-31 |
2020-02-29 |
|
|
1 |
|
|
|
2020-01-31 |
2024-01-30 |
|
|
47 |
|
|
|
2020-01-31 |
2019-02-28 |
|
|
-11 |
|
|
|
2020-01-31 |
2016-01-30 |
|
|
-48 |
|
|
NearestWeekday( a, b ) |
2020-02-27 |
6 |
|
|
2020-02-29 |
|
|
|
2020-02-27 |
-6 |
|
|
2020-02-22 |
|
|
Ordinal( a ) |
0 |
|
|
|
Zeroth |
|
|
|
12 |
|
|
|
Twelfth |
|
|
|
100 |
|
|
|
One Hundredth |
|
|
|
101 |
|
|
|
One Hundred and First |
|
|
|
123 |
|
|
|
One Hundred and Twenty Third |
|
|
|
200 |
|
|
|
Two Hundredth |
|
|
|
1001 |
|
|
|
One Thousand and First |
|
|
|
3000 |
|
|
|
Three Thousandth |
|
|
|
12345 |
|
|
|
Twelve Thousand Three Hundred and Forty Fifth |
|
|
|
4000000 |
|
|
|
Four Millionth |
|
|
|
1234567890 |
|
|
|
One Billion Two Hundred and Thirty Four Million Five Hundred and Sixty Seven Thousand Eight Hundred and Ninetieth |
|
|
|
5000000000 |
|
|
|
Five Billionth |
|
|
OrdinalSuffix( a ) |
0 |
|
|
|
0th |
|
|
|
1 |
|
|
|
1st |
|
|
|
2 |
|
|
|
2nd |
|
|
|
3 |
|
|
|
3rd |
|
|
|
10 |
|
|
|
10th |
|
|
|
11 |
|
|
|
11th |
|
|
|
12 |
|
|
|
12th |
|
|
|
13 |
|
|
|
13th |
|
|
|
101 |
|
|
|
101st |
|
|
|
111 |
|
|
|
111th |
|
|
|
112 |
|
|
|
112th |
|
|
|
113 |
|
|
|
113th |
|
|
|
123 |
|
|
|
123rd |
|
|
|
1001 |
|
|
|
1001st |
|
|
|
12342 |
|
|
|
12342nd |
|
|
|
1234567891 |
|
|
|
1234567891st |
|
|
|
3001234567891 |
|
|
|
3001234567891st |
|
|
PositionOf( a, b ) |
b,a,c,a,d,b,a |
a |
|
|
2 |
|
|
|
b,a,c,a,d,b,a |
b |
|
|
1 |
|
|
|
b,a,c,a,d,b,a |
d |
|
|
5 |
|
|
|
b,a,c,a,d,b,a |
e |
|
|
... |
|
|
Product( a ) |
Empty
List |
|
|
|
1 |
|
|
|
1,2,3,4 |
|
|
|
24 |
|
|
ReplaceAll( a, b, c ) |
AlphaBeta |
a |
a? |
|
Alpha?Beta? |
|
|
|
AlphaBeta |
A |
Empty Text |
|
lphaBeta |
|
|
Reverse( a ) |
Empty List |
|
|
|
Empty |
|
|
|
b,a,c,a,d,b,a |
|
|
|
a,b,d,a,c,a,b |
|
|
RoundAwayZero( a, b ) |
0.12345 |
3 |
|
|
0.123 |
|
|
|
0.12345 |
4 |
|
|
0.1235 |
|
|
|
0.12345 |
5 |
|
|
0.12345 |
|
|
|
-0.12345 |
3 |
|
|
-0.123 |
|
|
|
-0.12345 |
4 |
|
|
-0.1235 |
|
|
|
-0.12345 |
5 |
|
|
-0.12345 |
|
|
RoundBankers( a, b ) |
0.12345 |
4 |
|
|
0.1234 |
|
|
|
0.12435 |
4 |
|
|
0.1244 |
|
|
|
-0.12345 |
4 |
|
|
-0.1234 |
|
|
|
-0.12435 |
4 |
|
|
-0.1244 |
|
|
RoundTowardsZero( a, b ) |
0.12345 |
3 |
|
|
0.123 |
|
|
|
0.12345 |
4 |
|
|
0.1234 |
|
|
|
0.12345 |
5 |
|
|
0.12345 |
|
|
|
-0.12345 |
3 |
|
|
-0.123 |
|
|
|
-0.12345 |
4 |
|
|
-0.1234 |
|
|
|
-0.12345 |
5 |
|
|
-0.12345 |
|
|
SecondOf( a ) |
12:00:00 |
|
|
|
0 |
|
|
|
23:59:58 |
|
|
|
58 |
|
|
SecondsBetween( a, b ) |
12:00:00 |
23:59:58 |
|
|
43,198 |
|
|
|
23:59:58 |
11:59:58 |
|
|
-43,200 |
|
|
SubText( a, b, c ) |
AlphaBeta |
6 |
3 |
|
Bet |
|
|
|
AlphaBeta |
6 |
|
|
Beta |
|
|
|
AlphaBeta |
-6 |
3 |
|
haB |
|
|
|
AlphaBea |
-6 |
|
|
haBeta |
|
|
Sum( a ) |
Empty
List |
|
|
|
0 |
|
|
|
1,2,3,4 |
|
|
|
10 |
|
|
Term( a, b, c ) |
2020/01/01 |
2021/03/03 |
|
|
1 Year,2 Months,3 Days |
|
|
|
03:45:30 |
18:30:45 |
|
|
14 Hours,45 Minutes |
|
|
|
18:30:45 |
03:45:30 |
|
|
9 Hours,14 Minutes |
|
|
Time( a, b, c ) |
12:00:00 |
|
|
|
12:00:00 |
|
|
|
23:59:59 |
|
|
|
23:59:59 |
|
|
ToBoolean( a ) |
true |
|
|
|
Yes |
|
|
|
TRUE |
|
|
|
Yes |
|
|
|
1 |
|
|
|
Yes |
|
|
|
-123 |
|
|
|
Yes |
|
|
|
false |
|
|
|
No |
|
|
|
yes |
|
|
|
No |
|
|
|
0 |
|
|
|
No |
|
|
|
true,false |
|
|
|
Yes,No |
|
|
|
2020-01-31 |
|
|
|
... |
|
|
ToDate( a ) |
0 |
|
|
|
1970-01-01 |
|
|
|
2020-1-31 |
|
|
|
2020-01-31 |
|
|
|
0,1 |
|
|
|
1970-01-01,1970-01-02 |
|
|
|
true |
|
|
|
... |
|
|
Today() |
|
|
|
|
2023-07-09 |
|
|
ToInteger( a ) |
true |
|
|
|
1 |
|
|
|
false |
|
|
|
0 |
|
|
|
123 |
|
|
|
123 |
|
|
|
-123 |
|
|
|
-123 |
|
|
|
123.900 |
|
|
|
123 |
|
|
|
-123.900 |
|
|
|
-123 |
|
|
|
1970-01-01 |
|
|
|
0 |
|
|
|
true,false |
|
|
|
1,0 |
|
|
|
foo |
|
|
|
... |
|
|
ToLetters( a ) |
0 |
|
|
|
Empty |
|
|
|
1 |
|
|
|
A |
|
|
|
26 |
|
|
|
Z |
|
|
|
27 |
|
|
|
AA |
|
|
|
52 |
|
|
|
AZ |
|
|
ToNumber( a ) |
true |
|
|
|
1 |
|
|
|
false |
|
|
|
0 |
|
|
|
123 |
|
|
|
123 |
|
|
|
-123 |
|
|
|
-123 |
|
|
|
123.900 |
|
|
|
123.9 |
|
|
|
-123.900 |
|
|
|
-123.9 |
|
|
|
1970-01-01 |
|
|
|
0 |
|
|
|
true,false |
|
|
|
1,0 |
|
|
|
foo |
|
|
|
... |
|
|
ToRoman( a ) |
1 |
|
|
|
I |
|
|
|
5 |
|
|
|
V |
|
|
|
10 |
|
|
|
X |
|
|
|
50 |
|
|
|
L |
|
|
|
100 |
|
|
|
C |
|
|
|
500 |
|
|
|
D |
|
|
|
1000 |
|
|
|
M |
|
|
|
1794 |
|
|
|
MDCCXCIV |
|
|
ToText( a ) |
true |
|
|
|
true |
|
|
|
false |
|
|
|
false |
|
|
|
0 |
|
|
|
0 |
|
|
|
-1 |
|
|
|
-1 |
|
|
|
0.5 |
|
|
|
0.5 |
|
|
|
-123.45 |
|
|
|
-123.45 |
|
|
|
2020-1-1 |
|
|
|
2020-01-01 |
|
|
|
2020-1-1,2020-1-31 |
|
|
|
2020-01-01,2020-01-31 |
|
|
|
1:2:3 |
|
|
|
01:02:03 |
|
|
|
1:2:3,23:59:59 |
|
|
|
01:02:03,23:59:59 |
|
|
ToTime( a ) |
1:2:3 |
|
|
|
01:02:03 |
|
|
|
3723 |
|
|
|
01:02:03 |
|
|
Union( a, b ) |
Empty
List |
Empty
List |
|
|
Empty |
|
|
|
b,a,c,a,d,b,a |
Empty
List |
|
|
b,a,c,d |
|
|
|
b,a,c,a,d,b,a |
b,a,e,f,e |
|
|
b,a,c,d,e,f |
|
|
UpperCase( a ) |
Empty |
|
|
|
Empty |
|
|
|
AlphaBetaGamma |
|
|
|
ALPHABETAGAMMA |
|
|
WeekdayOf( a ) |
2020-01-27 |
|
|
|
1 |
|
|
|
2020-02-02 |
|
|
|
7 |
|
|
WeekNumber( a ) |
2020-02-29 |
|
|
|
9 |
|
|
|
2021-02-28 |
|
|
|
10 |
|
|
WorkDay( a, b, c, d ) |
2008-01-10 |
151 |
|
|
2009-04-30 |
|
|
|
2008-01-10 |
151 |
2008-11-26 2008-12-04 2009-01-21 |
|
2009-05-05 |
|
|
|
2008-01-10 |
151 |
2008-11-26 2008-12-04 2009-01-21 2009-01-24 2009-01-25 |
|
2009-05-05 |
|
|
|
2008-01-10 |
151 |
2008-11-26 2008-12-04 2009-01-21 2009-01-24 2009-01-25 2009-05-05 2009-05-06 2009-05-07 2009-05-08 2009-05-09 2009-05-10 |
|
2009-05-11 |
|
|
|
2008-01-10 |
151 |
2008-11-26 2008-12-04 2009-01-21 |
6 7 |
2009-05-05 |
|
|
|
2008-01-10 |
151 |
2008-11-26 2008-12-04 2009-01-21 |
5 6 7 |
2009-06-29 |
|
|
YearOf( a ) |
2020-01-31 |
|
|
|
2,020 |
|
|
YearsBetween( a, b ) |
2020-01-31 |
2021-01-30 |
|
|
0 |
|
|
|
2020-01-31 |
2024-01-31 |
|
|
4 |
|
|
|
2020-01-31 |
2019-01-30 |
|
|
-1 |
|
|
|
2020-01-31 |
2016-01-31 |
|
|
-4 |
|
|
Row |
Column |
Cell |
Height |
HeightNoWording |
Width |
WidthNoWording |
Style |
Note |
|
single |
|
|
100% |
|
|
|
|
The row containing the wording |
|
|
single |
|
|
|
100% |
|
|
The column containing the wording |
|
|
|
Wording |
100% |
|
|
|
|
The wording of the document to be
assembled |
|
Group |
Setting |
Value |
Note |
|
Wording |
Visible |
true |
The wording is initially
visible |